翻訳と辞書
Words near each other
・ "O" Is for Outlaw
・ "O"-Jung.Ban.Hap.
・ "Ode-to-Napoleon" hexachord
・ "Oh Yeah!" Live
・ "Our Contemporary" regional art exhibition (Leningrad, 1975)
・ "P" Is for Peril
・ "Pimpernel" Smith
・ "Polish death camp" controversy
・ "Pro knigi" ("About books")
・ "Prosopa" Greek Television Awards
・ "Pussy Cats" Starring the Walkmen
・ "Q" Is for Quarry
・ "R" Is for Ricochet
・ "R" The King (2016 film)
・ "Rags" Ragland
・ ! (album)
・ ! (disambiguation)
・ !!
・ !!!
・ !!! (album)
・ !!Destroy-Oh-Boy!!
・ !Action Pact!
・ !Arriba! La Pachanga
・ !Hero
・ !Hero (album)
・ !Kung language
・ !Oka Tokat
・ !PAUS3
・ !T.O.O.H.!
・ !Women Art Revolution


Dictionary Lists
翻訳と辞書 辞書検索 [ 開発暫定版 ]
スポンサード リンク

fourth normal form : ウィキペディア英語版
fourth normal form
Fourth normal form (4NF) is a normal form used in database normalization. Introduced by Ronald Fagin in 1977, 4NF is the next level of normalization after Boyce–Codd normal form (BCNF). Whereas the second, third, and Boyce–Codd normal forms are concerned with functional dependencies, 4NF is concerned with a more general type of dependency known as a multivalued dependency. A Table is in 4NF if and only if, for every one of its non-trivial multivalued dependencies ''X'' \twoheadrightarrow ''Y'', ''X'' is a superkey—that is, ''X'' is either a candidate key or a superset thereof.〔"A relation schema R
* is in fourth normal form (4NF) if, whenever a nontrivial multivalued dependency X \twoheadrightarrow Y holds for R
*, then so does the functional dependency X → A for every column name A of R
*. Intuitively all dependencies are the result of keys." 〕
==Multivalued dependencies==
If the column headings in a relational database table are divided into three disjoint groupings ''X'', ''Y'', and ''Z'', then, in the context of a particular row, we can refer to the data beneath each group of headings as ''x'', ''y'', and ''z'' respectively. A multivalued dependency ''X'' \twoheadrightarrow ''Y'' signifies that if we choose any ''x'' actually occurring in the table (call this choice ''xc''), and compile a list of all the ''xcyz'' combinations that occur in the table, we will find that ''xc'' is associated with the same ''y'' entries regardless of ''z''. So essentially the presence of z provides no useful information to constrain the possible values of ''y''.
A trivial multivalued dependency ''X'' \twoheadrightarrow ''Y'' is one where either ''Y'' is a subset of ''X'', or ''X'' and ''Y'' together form the whole set of attributes of the relation.
A functional dependency is a special case of multivalued dependency. In a functional dependency ''X'' → ''Y'', every ''x'' determines ''exactly one y'', never more than one.

抄文引用元・出典: フリー百科事典『 ウィキペディア(Wikipedia)
ウィキペディアで「fourth normal form」の詳細全文を読む



スポンサード リンク
翻訳と辞書 : 翻訳のためのインターネットリソース

Copyright(C) kotoba.ne.jp 1997-2016. All Rights Reserved.